/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 17:50:08
*/


-- ----------------------------
-- Table structure for tb0041
-- ----------------------------
DROP TABLE [dbo].[tb0041]
GO
CREATE TABLE [dbo].[tb0041] (
[EmployeeTypeID] varchar(20) NOT NULL ,
[EmployeeName] nvarchar(100) NULL ,
[Disabled] tinyint NOT NULL DEFAULT ((0)) ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL 
)


GO

-- ----------------------------
-- Records of tb0041
-- ----------------------------
INSERT INTO [dbo].[tb0041] ([EmployeeTypeID], [EmployeeName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'KT', N'Kế toán', N'0', N'2008-12-28 18:20:38.487', N'ADMIN', N'2008-12-28 18:20:38.487', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0041] ([EmployeeTypeID], [EmployeeName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'KD', N'Kinh doanh', N'0', N'2012-10-14 19:42:41.447', N'ADMIN', N'2012-10-14 19:42:41.447', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0041] ([EmployeeTypeID], [EmployeeName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'KHO', N'Kho', N'0', N'2013-01-01 09:52:24.287', N'ADMIN', N'2013-01-01 09:52:24.287', N'ADMIN')
GO
GO

-- ----------------------------
-- Indexes structure for table tb0041
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0041
-- ----------------------------
ALTER TABLE [dbo].[tb0041] ADD PRIMARY KEY NONCLUSTERED ([EmployeeTypeID])
GO
